﻿<html DIR="LTR" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:MSHelp="http://msdn.microsoft.com/mshelp">
  <head>
    <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" />
    <META NAME="save" CONTENT="history" />
    <title>AdventureWorksOffline Report Samples</title>
    
    
    
    <style TYPE="text/css">
body
{
background: #FFFFFF;
color: #000000;
font-family:    Verdana;
font-size: medium;
font-style: normal;
font-weight: normal;
margin-top: 0;
margin-bottom:  0;
margin-left:    0;
margin-right:   0;
width:  100%;
}

div.#mainSection
{
font-size: 70%;
width: 100%;
padding-left:    10;
margin-right: 10;
}

div.#mainBody
{
font-size: 90%;
margin-top: 10;
padding-bottom: 20;
}

div.#header
{
background-color: #D2D2D2;
padding-top:    0;
padding-bottom: 0;
padding-left:   10;
padding-right:  0;
width:          100%;
}

div.#header table
{
border-bottom-color: #C8CDDE;
border-bottom-style: solid;
border-bottom-width: 1;
width:  100%;
}

span.#runningHeaderText
{
color: #003399;
font-size: 90%;
}

span.#nsrTitle
{
/*    color: #003399;*/
font-size: 120%;
font-weight: 600;
}

div.#header table td
{
color: #000000;
font-size: 70%;
margin-top: 0;
margin-bottom:  0;
padding-right: 20;
}

div.#header table tr.#headerTableRow3 td
{
padding-bottom: 2;
padding-top: 5;
}

div.#header table.#bottomTable
{
border-top-color: #FFFFFF;
border-top-style: solid;
border-top-width: 1;
text-align: left;
}

div.#footer
{
font-size: 90%;
margin-top: 0;
margin-bottom:  0;
margin-left:    -5;
margin-right:   0;
padding-top:    2;
padding-bottom: 2;
padding-left:   0;
padding-right:  0;
width:  100%;
}

hr.#footerHR
{
border-bottom-color: #EEEEFF;
border-bottom-style: solid;
border-bottom-width: 1;
border-top-color: C8CDDE;
border-top-style: solid;
border-top-width: 1;
height: 3;
color: #D2D2D2;
}

div.section
{
padding-top:    2;
padding-bottom: 2;
padding-right:  15;
width:  100%;
}

.heading
{
color:          #000000;
font-weight:    bold;
margin-top:     18;
margin-bottom:  8;
}

h1.heading
{
color: #000000;
font-size:  150%;
}

.subHeading
{
color:          #000000;
font-weight:    bold;
font-size:      150%;
margin-bottom:  4;
}

h2.subHeading
{
color:          #000000;
font-weight:    bold;
font-size:      130%;
}
h3.subHeading
{
color:  #000000;
font-size: 125%;
font-weight: bold;
}

h4.subHeading
{
color: #000000;
font-size: 110%;
font-weight: bold;
}

h4.procedureHeading
{
color: #000080;
font-size: 110%;
font-weight: bold;
}

h5.subHeading
{
color: #000000;
font-size: 100%;
font-weight: bold;
}

img
{
padding-bottom: 10;
}

img.toggle
{
border: 0;
margin-right: 5;
padding-bottom: 10;
}

img.copyCodeImage
{
border: 0;
margin: 1;
margin-right: 3;
padding-bottom: 10;
}

img.downloadCodeImage
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.viewCodeImage
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.note
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.#membersOptionsFilterImage
{
border: 0;
margin-left: 10;
vertical-align: middle;
padding-bottom: 10;
}

img.#toggleAllImage
{
margin-left: 4;
vertical-align: middle;
padding-bottom: 10;
}

div.#mainSection table
{
border: 0;
font-size: 100%;
width:  100%;
margin-top: 5px;
margin-bottom: 15px;
}

div.#mainSection table tr
{
vertical-align: top;
}

div.#mainSection table th
{
text-align: left;
background: #D8D8D8;
border-bottom-color: #D8D8D8;
border-bottom-style: solid;
border-bottom-width: 1;
color: #000000;
padding-left: 5;
padding-right: 5;
}

div.#mainSection table td
{
background: #F2F2F2;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
}

div.#mainSection table td.imageCell
{
white-space: nowrap;
}

div.code
{
width: 98%;
}

div.code table
{
border: 0;
font-size: 95%;
margin-bottom: 5;
width: 100%
}

div.code table th
{
text-align: left;
background: #D8D8D8;
border-bottom-color: #D8D8D8;
border-bottom-style: solid;
border-bottom-width: 1;
color: #000000;
font-weight: bold;
padding-left: 5;
padding-right: 5;
}

div.code table td
{
background: #CCCCCC;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
padding-top: 5;
}

div.alert
{
margin-left: 10;
width: 98%;
}

div.alert table
{
border: 1;
font-size: 100%;
width:  100%;
border: solid 1 #DEDFEF;
}

div.alert table th
{
text-align: left;
background: #D8D8D8;
border-bottom-width: 0;
color: #000000;
padding-left: 5;
padding-right: 5;
border: solid 1 #DEDFEF;
}

div.alert table td
{
background: #FFFFFF;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
border: solid 1 #DEDFEF;
}

span.copyCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
float: right;
display: inline;
text-align: right;
}

.downloadCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
}

.viewCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
}

div.code pre
{
font-family:    Monospace, Courier New, Courier;
font-size: 105%;
color:  #000000;
}

code
{
font-family:    Monospace, Courier New, Courier;
font-size: 105%;
color:  #000000;
}

dl
{
margin-top: 0;
padding-left:   1;
}

dd
{
margin-bottom:  0;
margin-left:    0;
padding-left:   20;
}

dd p
{
margin-top: 5;
}

ul
{
margin-left: 17;
list-style-type: disc;
}

ul ul
{
margin-bottom: 4;
margin-left: 17;
margin-top: 3;
list-style-type: disc;
}

ol
{
margin-left: 24;
list-style-type: decimal;
}

ol ol
{
margin-left: 24;
margin-top: 3;
list-style-type: lower-alpha;
}

li
{
margin-top: 0;
margin-bottom: 0;
padding-bottom: 0;
padding-top: 0;
margin-left: 5;
}

p
{
margin-bottom: 15;
}

.tip
{
color:  #0000FF;
font-style: italic;
cursor:hand;
text-decoration:underline;
}

.math
{
font-family: Times New Roman;
font-size: 125%
}
.sourceCodeList
{
font-family: Verdana;
font-size: 90%;
}

pre.viewCode
{
width: 100%;
overflow: auto;
}

li:hover table, li.over table
{
background-color: #C0C0C0;
}

li:hover ul, li.over ul
{
background-color: #d2d2d2;
border: 1px solid #000;
display: block;
}
            </style>
  </head>
  <body>
    <!--Topic built:10/14/2008 23:13:37-->

    
    
    
    
    
    
    
    
    
    <div id="header">
      <table width="100%" id="topTable"><tr>
          <td align="left">
            <span id="nsrTitle">AdventureWorksOffline Report Samples</span>
          </td>
          <td align="right">
            <span id="headfb" class="feedbackhead">
            </span>
          </td>
        </tr></table>
      
      
      
    </div>
    <div id="mainSection">
      <div id="mainBody"><p> 10/14/2008 23:13:37</p>
        
        <font color="DarkGray"> </font><p /> 
        <span id="changeHistory">
        </span>
    <p>The AdventureWorksOffline report samples are a set of predefined report definition files that use XML representations of data taken from the <b>AdventureWorks</b> databases. As a result, the AdventureWorksOffline report samples do not require an active connection to the AdventureWorks. You can use these sample reports to familiarize yourself with individual features of when authoring reports.</p>
  <h1 class="heading">Scenario</h1><div id="sectionSection0" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">
        Adventure Works Cycles publishes product and sales information that is accessed by employees throughout the company. The reports present this data in a variety of formats.</p>
    </content></div><h1 class="heading">Language</h1><div id="sectionSection1" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Report Definition Language (RDL)</p>
    </content></div><h1 class="heading">Chart Sample Reports</h1><div id="sectionSection2" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The AdventureWorks sample reports demonstrate a wide range of report features. The following table provides descriptions that explain the chart samples that are available. </p>
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Report
            </th>
            <th>
              Description
            </th>
          </tr><tr>
          <td>
            <p>_AreaCharts</p>
          </td>
          <td>
            <p>This report illustrates properties related to the area chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_BarCharts_VisualEffects</p>
          </td>
          <td>
            <p>This report illustrates the visual effects that can be set on a bar or column chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_FunnelCharts</p>
          </td>
          <td>
            <p>This report illustrates how to set properties on the funnel chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_LineCharts</p>
          </td>
          <td>
            <p>This report illustrates how to set properties on a line chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_PieCharts_CollectingSlices</p>
          </td>
          <td>
            <p>This report illustrates how to collect small slices on a pie chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_PieCharts_DisplayingLabelsOutside</p>
          </td>
          <td>
            <p>This report illustrates how to display labels around the outside of a pie chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_PieCharts_VisualEffects</p>
          </td>
          <td>
            <p>This report illustrates various visual effects that can be set on a pie or doughnut chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_RadarCharts</p>
          </td>
          <td>
            <p>This report illustrates how to set properties on a radar chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_Stock Charts</p>
          </td>
          <td>
            <p>This report illustrates how to set properties on a stock chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>Appearance_BorderSkins</p>
          </td>
          <td>
            <p>This report illustrates various border skins that can be applied to the chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>Appearance_ColorPalette</p>
          </td>
          <td>
            <p>This report illustrates various color palettes that can be applied to the chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>Axis_ScaleBreaks</p>
          </td>
          <td>
            <p>This report illustrates how the chart calculates a scale break if there is sufficient space.</p>
          </td>
        </tr><tr>
          <td>
            <p>Axis_SecondaryAxis</p>
          </td>
          <td>
            <p>This report illustrates how to make use of the secondary axis.</p>
          </td>
        </tr><tr>
          <td>
            <p>Axis_SpecifyNumOfIntervals</p>
          </td>
          <td>
            <p>This report illustrates how to show all labels on an axis.</p>
          </td>
        </tr><tr>
          <td>
            <p>Data_AddingCalculatedSeries</p>
          </td>
          <td>
            <p>This report illustrates how to add a calculated series to a chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>Data_HighlightMaxPoint</p>
          </td>
          <td>
            <p>This report illustrates how to highlight the maximum data point in a series.</p>
          </td>
        </tr><tr>
          <td>
            <p>Data_HandlingEmptyPoints</p>
          </td>
          <td>
            <p>This report illustrates how to handle null values by adding empty points to the chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>Data_Trendlines</p>
          </td>
          <td>
            <p>This report illustrates how to add a trend line to the chart.</p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Gauge Sample Reports</h1><div id="sectionSection3" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The AdventureWorks sample reports demonstrate a wide range of report features. The following table provides descriptions that explain the gauge samples that are available. </p>
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Report
            </th>
            <th>
              Description
            </th>
          </tr><tr>
          <td>
            <p>Gallery_MetallicFrameGauge</p>
          </td>
          <td>
            <p>This report contains an example of a metallic frame gauge. </p>
          </td>
        </tr><tr>
          <td>
            <p>Gallery_Thermometer</p>
          </td>
          <td>
            <p>This report contains an example of a thermometer. </p>
          </td>
        </tr><tr>
          <td>
            <p>Gallery_TurboRPMGauge</p>
          </td>
          <td>
            <p>This report contains an example of a turbo RPM gauge. </p>
          </td>
        </tr><tr>
          <td>
            <p>Pointers</p>
          </td>
          <td>
            <p>This report illustrates how to format the gauge pointer.</p>
          </td>
        </tr><tr>
          <td>
            <p>Scales</p>
          </td>
          <td>
            <p>This report illustrates how to format the gauge scale.</p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Text Sample Reports</h1><div id="sectionSection4" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The AdventureWorks sample reports demonstrate a wide range of report features. The following table provides descriptions that explain the text samples that are available. </p>
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Report
            </th>
            <th>
              Description
            </th>
          </tr><tr>
          <td>
            <p>HTML_Import</p>
          </td>
          <td>
            <p>This report illustrates how to import HTML into a text box..</p>
          </td>
        </tr><tr>
          <td>
            <p>HTML_MailMerge</p>
          </td>
          <td>
            <p>This report illustrates how to create a mail merge after importing HTML into a text box.</p>
          </td>
        </tr><tr>
          <td>
            <p>Text_FormattingSelected</p>
          </td>
          <td>
            <p>This report illustrates how to mix multiple formats inside of a single text box.</p>
          </td>
        </tr><tr>
          <td>
            <p>Text_MailMerge</p>
          </td>
          <td>
            <p>This report illustrates how to create a mail merge inside of a single text box.</p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Prerequisites</h1><div id="sectionSection5" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Your system must have Business Intelligence Development Studio installed.</p>
      <div class="alert" xmlns=""><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left">Note: </th></tr><tr><td>
        Business Intelligence (BI) Development Studio is not supported on Itanium-based computers. However, support for BI Development Studio is available for x64-based computers. If the SQL Server sample databases have been deployed on an Itanium-based computer, use BI Development Studio on either an x86-based or x64-based computer to modify and run the samples.<p />
      </td></tr></table><p /></div>
    </content></div><h1 class="heading">See Also</h1><div id="seeAlsoSection" class="section" name="collapseableSection"><h4 class="subHeading">Tasks</h4><a href="html/e8117979-fe03-441e-be85-894fa616227a.htm">Considerations for Installing SQL Server Samples and Sample Databases</a><br /><a href="html/a3c209ec-283f-4d74-a3a2-899e89ebbec0.htm">AdventureWorks Report Samples</a><br /><h4 class="subHeading">Other Resources</h4><b>Working with Chart Data Regions</b><br /><b>Working with Gauge Data Regions</b><br /><br />
		<h4 class="subHeading">
			Help and Information
		</h4>
		<b>
			
			Getting SQL Server 2008 Assistance
		</b>
	</div><!--[if gte IE 5]>
			<tool:tip element="seeAlsoToolTip" avoidmouse="false"/><tool:tip element="languageFilterToolTip" avoidmouse="false"/><tool:tip element="roleInfoSpan" avoidmouse="false"/>
		<![endif]--></div>
      <div id="footer">
			
			© 2008 Microsoft Corporation. All rights reserved.
		</div>
    </div>
  </body>
</html>